#!usr/bin/env python  
# -*- coding:utf-8 _*-
""" 
@author:robot
@file: mysql01.py 
@version:
@time: 2022/01/17 
"""
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import SQLSERVER06_TYPE
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import generate_columns_data

SQLSERVER06_COLUMNS = SQLSERVER06_TYPE.get('COLUMNS')

BASE = SQLSERVER06_COLUMNS.get('BASE')
PK = BASE.get('PK').lower()
NO_PK = BASE.get('NO PK').lower()

# ****EXACT_NUMERICS*****
EXACT_NUMERICS = SQLSERVER06_COLUMNS.get('EXACT_NUMERICS')

# ****APPROXIMATE_NUMERICS****
APPROXIMATE_NUMERICS = SQLSERVER06_COLUMNS.get('APPROXIMATE_NUMERICS')

# ****DATE_AND_TIME****
DATE_AND_TIME = SQLSERVER06_COLUMNS.get('DATE_AND_TIME')

# ****CHARACTER_STRINGS****
CHARACTER_STRINGS = SQLSERVER06_COLUMNS.get('CHARACTER_STRINGS')

# ****UNICODE_CHARACTER_STRINGS****
UNICODE_CHARACTER_STRINGS = SQLSERVER06_COLUMNS.get('UNICODE_CHARACTER_STRINGS')

# *****BINARY_STRINGS****
BINARY_STRINGS = SQLSERVER06_COLUMNS.get('BINARY_STRINGS')

# ****OTHER_DATA_TYPES****
OTHER_DATA_TYPES = SQLSERVER06_COLUMNS.get('OTHER_DATA_TYPES')

# --EXACT_NUMERICS--
tinyint = EXACT_NUMERICS.get('tinyint').get('CREATE')
smallint = EXACT_NUMERICS.get('smallint').get('CREATE')
INT = EXACT_NUMERICS.get('int').get('CREATE')
bigint = EXACT_NUMERICS.get('bigint').get('CREATE')
decimal = EXACT_NUMERICS.get('decimal').get('CREATE')
numeric = EXACT_NUMERICS.get('numeric').get('CREATE')
bit = EXACT_NUMERICS.get('bit').get('CREATE')
smallmoney = EXACT_NUMERICS.get('smallmoney').get('CREATE')
money = EXACT_NUMERICS.get('money').get('CREATE')

# --APPROXIMATE_NUMERICS--
FLOAT = APPROXIMATE_NUMERICS.get('float').get('CREATE')
real = APPROXIMATE_NUMERICS.get('real').get('CREATE')

# --DATE_AND_TIME--
date = DATE_AND_TIME.get('date').get('CREATE')
datetimeoffset = DATE_AND_TIME.get('datetimeoffset').get('CREATE')
datetime2 = DATE_AND_TIME.get('datetime2').get('CREATE')
smalldatetime = DATE_AND_TIME.get('smalldatetime').get('CREATE')
datetime = DATE_AND_TIME.get('datetime').get('CREATE')
time = DATE_AND_TIME.get('time').get('CREATE')

# --CHARACTER_STRINGS--
char = CHARACTER_STRINGS.get('char').get('CREATE')
varchar = CHARACTER_STRINGS.get('varchar').get('CREATE')
text = CHARACTER_STRINGS.get('text').get('CREATE')

# --UNICODE_CHARACTER_STRINGS--
nchar = UNICODE_CHARACTER_STRINGS.get('nchar').get('CREATE')
nvarchar = UNICODE_CHARACTER_STRINGS.get('nvarchar').get('CREATE')
ntext = UNICODE_CHARACTER_STRINGS.get('ntext').get('CREATE')

# --*BINARY_STRINGS--
binary = BINARY_STRINGS.get('binary').get('CREATE')
varbinary = BINARY_STRINGS.get('varbinary').get('CREATE')
image = BINARY_STRINGS.get('image').get('CREATE')

# --OTHER_DATA_TYPES--
cursor = OTHER_DATA_TYPES.get('cursor').get('CREATE')
rowversion = OTHER_DATA_TYPES.get('rowversion').get('CREATE')
hierarchyid = OTHER_DATA_TYPES.get('hierarchyid').get('CREATE')
uniqueidentifier = OTHER_DATA_TYPES.get('uniqueidentifier').get('CREATE')
sql_variant = OTHER_DATA_TYPES.get('sql_variant').get('CREATE')
xml = OTHER_DATA_TYPES.get('xml').get('CREATE')
table = OTHER_DATA_TYPES.get('table').get('CREATE')
geometry = OTHER_DATA_TYPES.get('geometry').get('CREATE')
geography = OTHER_DATA_TYPES.get('geography').get('CREATE')
